/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80039
 Source Host           : localhost:3306
 Source Schema         : cyzs

 Target Server Type    : MySQL
 Target Server Version : 80039
 File Encoding         : 65001

 Date: 07/01/2025 17:45:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_cm_measure
-- ----------------------------
DROP TABLE IF EXISTS `t_cm_measure`;
CREATE TABLE `t_cm_measure` (
  `cmm_id` bigint NOT NULL DEFAULT '0' COMMENT '序号',
  `cus_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '客户编码',
  `cus_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '姓名',
  `build_address` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地址',
  `house_area` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '外框面积',
  `designer_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '设计师',
  `budgeter_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '预算员',
  `material_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '材料员',
  `supervisor` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '监理',
  `mng_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '项目经理/管家',
  `sign_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '施工合同签订日期',
  `plan_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '计划完工日期',
  `start_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '实际开工日期',
  `material_sub_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '选材单提交日期',
  `finance_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '财务状况',
  `build_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '施工状况',
  `first_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交齐首付款日期',
  `mid_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交齐中期款日期',
  `bottom_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交齐尾款日期',
  `start_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交开工款日期',
  `contract_money` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '合同金额',
  `pay_eng_money` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '已收工程款',
  `build_ratio` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '开单比例',
  `db_brand` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-品牌',
  `db_create_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-制单时间',
  `db_order_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-下单状态',
  `db_measure_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-测量反馈日期',
  `db_mng_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-项目经理确认日期',
  `db_measure_begin_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-测量状态',
  `db_measure_finish_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-测量制作完成时间',
  `cg_brand` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-品牌',
  `cg_create_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-制单时间',
  `cg_order_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-下单状态',
  `cg_measure_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-测量反馈日期',
  `cg_mng_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-项目经理确认日期',
  `cg_measure_begin_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-测量状态',
  `cg_measure_finish_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-测量制作完成时间',
  `dzg_brand` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-品牌',
  `dzg_create_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-制单时间',
  `dzg_order_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-下单状态',
  `dzg_measure_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-测量反馈日期',
  `dzg_mng_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-项目经理确认日期',
  `dzg_measure_begin_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-测量状态',
  `dzg_measure_finish_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-测量制作完成时间',
  `dls_brand` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-品牌',
  `dls_create_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-制单时间',
  `dls_order_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-下单状态',
  `dls_measure_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-测量反馈日期',
  `dls_mng_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-项目经理确认日期',
  `dls_measure_begin_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-测量状态',
  `dls_measure_finish_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-测量制作完成时间',
  `lhj_brand` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-品牌',
  `lhj_create_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-制单时间',
  `lhj_order_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-下单状态',
  `lhj_measure_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-测量反馈日期',
  `lhj_mng_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-项目经理确认日期',
  `lhj_measure_begin_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-测量状态',
  `lhj_measure_finish_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-测量制作完成时间',
  `fm_brand` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-品牌',
  `fm_create_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-制单时间',
  `fm_order_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-下单状态',
  `fm_measure_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-测量反馈日期',
  `fm_mng_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-项目经理确认日期',
  `fm_measure_begin_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-测量状态',
  `fm_measure_finish_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-测量制作完成时间',
  `cp_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '公司编号',
  `cp_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '公司名称',
  `org_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '门店编号',
  `org_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '门店名称',
  `material_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '材料员编号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`cmm_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_cm_measure
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_cm_send
-- ----------------------------
DROP TABLE IF EXISTS `t_cm_send`;
CREATE TABLE `t_cm_send` (
  `cms_id` bigint NOT NULL DEFAULT '0' COMMENT '序号',
  `cus_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '客户编码',
  `cus_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '姓名',
  `build_address` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地址',
  `house_area` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '外框面积',
  `designer_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '设计师',
  `budgeter_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '预算员',
  `material_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '材料员',
  `supervisor` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '监理',
  `mng_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '项目经理/管家',
  `sign_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '施工合同签订日期',
  `plan_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '计划完工日期',
  `start_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '实际开工日期',
  `material_sub_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '选材单提交日期',
  `finance_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '财务状况',
  `build_state` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '施工状况',
  `first_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交齐首付款日期',
  `mid_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交齐中期款日期',
  `bottom_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交齐尾款日期',
  `start_pay_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '交开工款日期',
  `contract_money` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '合同金额',
  `pay_eng_money` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '已收工程款',
  `build_ratio` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '开单比例',
  `cz_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '瓷砖-供应商   ',
  `cz_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '瓷砖-下单日期  ',
  `cz_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '瓷砖-送货日期  ',
  `cz_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '瓷砖-安装日期  ',
  `db_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-供应商   ',
  `db_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-下单日期  ',
  `db_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-送货日期  ',
  `db_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地板-安装日期  ',
  `jj_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '洁具-供应商   ',
  `jj_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '洁具-下单日期  ',
  `jj_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '洁具-送货日期  ',
  `jj_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '洁具-安装日期  ',
  `cg_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-供应商   ',
  `cg_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-下单日期  ',
  `cg_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-送货日期  ',
  `cg_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '橱柜-安装日期  ',
  `dzg_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-供应商  ',
  `dzg_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-下单日期 ',
  `dzg_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-送货日期 ',
  `dzg_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '定制柜-安装日期 ',
  `dls_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-供应商  ',
  `dls_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-下单日期 ',
  `dls_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-送货日期 ',
  `dls_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '大理石-安装日期 ',
  `kg_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '开关-供应商   ',
  `kg_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '开关-下单日期  ',
  `kg_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '开关-送货日期  ',
  `kg_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '开关-安装日期  ',
  `dj_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '灯具-供应商   ',
  `dj_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '灯具-下单日期  ',
  `dj_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '灯具-送货日期  ',
  `dj_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '灯具-安装日期  ',
  `lhjm_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-供应商 ',
  `lhjm_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-下单日期',
  `lhjm_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-送货日期',
  `lhjm_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '铝合金门-安装日期',
  `fm_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-供应商   ',
  `fm_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-下单日期  ',
  `fm_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-送货日期  ',
  `fm_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '房门-安装日期  ',
  `kb_supplier` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '扣板-供应商   ',
  `kb_order_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '扣板-下单日期  ',
  `kb_send_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '扣板-送货日期  ',
  `kb_install_dt` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '扣板-安装日期  ',
  `cp_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '公司编号',
  `cp_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '公司名称',
  `org_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '门店编号',
  `org_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '门店名称',
  `material_id` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '材料员编号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`cms_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_cm_send
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_cm_sync
-- ----------------------------
DROP TABLE IF EXISTS `t_cm_sync`;
CREATE TABLE `t_cm_sync` (
  `cms_id` bigint NOT NULL COMMENT '序号  ',
  `cms_dt` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '同步日期',
  `cms_type` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '同步类型',
  `cms_state` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '同步状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`cms_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of t_cm_sync
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_sys_code
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_code`;
CREATE TABLE `t_sys_code` (
  `code_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `code_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `code_desc` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`code_id`) USING BTREE,
  UNIQUE KEY `idx_code_name` (`code_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_code
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_sys_company
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_company`;
CREATE TABLE `t_sys_company` (
  `cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '公司编号',
  `cp_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `par_cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '上级公司编号',
  `cp_level` int NOT NULL DEFAULT '0' COMMENT '所在层级',
  `cp_address` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '所在地址',
  `cp_desc` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '公司描述',
  `contract_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '联系人',
  `contract_tel` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '联系电话',
  `contract_boss` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '公司法人',
  `cp_tel` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '公司联系电话',
  `cp_contract` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '合同',
  `cp_begin_dt` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '入驻开始时间',
  `cp_end_dt` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '入驻结束时间',
  `cp_state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '公司状态',
  `cp_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '公司余额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '创建用户',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '修改用户',
  `chk_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '审核人',
  `chk_tm` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '审核时间',
  `chk_remark` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '审核备注',
  `give_num` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '赠送工单数',
  `bill_type` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '计费方式',
  `bill_amount` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '计费金额/比例',
  `bill_begin_dt` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '计费开始时间',
  `bill_end_dt` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '计费结束时间',
  `dev_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '发展人',
  `commission_type` varchar(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '分佣类型',
  `commission_ratio` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '发展人',
  PRIMARY KEY (`cp_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_sys_company
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_company` VALUES ('028957d258214578a400768082363803', '合肥北店', 'ab6c901edeb842fbb9d32b2b0757aa04', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('02f484a19d984d009de43eeea5654da9', '昆明硬装', '08d6e83120f04e2d95f09cbca5e39f16', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('0455fa077bba4e0a8e02f6e81ee63fe1', '毕节杜鹃店', '0a9c3ff03733410f9afd87d1a702d42b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('05780461f55c4f2fa54d2a03705cfe4c', '红河', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('05eaeecef2784ef88cf5b25d06900d0d', '郴州创艺南塔店', 'd62c8b84a18b464f86cf7d9e95b0bede', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('075fff16157948c5968a0ab5e47e861b', '大理北店', '887d9d470959462da4f8c828c0cc8f44', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('08adfb9c92d649e4a6da8310d9b37694', '安阳', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('08d6e83120f04e2d95f09cbca5e39f16', '昆明', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('0947c880195242a180dd6c34510c3232', '遵义创艺', '5d8784bd2b2143be93bde9d07d5429ea', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('0a9c3ff03733410f9afd87d1a702d42b', '毕节', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('0c8aa72da56a4da384c1fe27ae9c9549', '安阳创艺', '08adfb9c92d649e4a6da8310d9b37694', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('12fd91e487dc4edf9da2e770431bd1c6', '宣城创艺', 'cafd7873c8654f05bfaa64af1c948b24', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('1552e34f95be42a49db3c6e34700107d', '桂林临桂店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('18604a83f64c4d9e91dc67b613752b4f', '兴义施达店', '2022070518331847193295', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('1984f2a74a294f8c811c2697aced2107', '赣州', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('19bfbfbf257749dfa792e5a5f00b680d', '南昌红谷滩店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('1ad42349e1fe4585ad30046797be7585', '宿州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('1bc33b61c000467c80d503e4cf3b356a', '高安', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022011216292015134983', '未知地区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022030917450369273537', '安顺玉龙店', 'fb94dd1c526043f0ba7d40fbbf3adfe2', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022032012071314248982', '桂平创艺', 'e1f450e27d6b41caba92aa4c3e567a68', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022032218273812072668', '未知城市', '2022011216292015134983', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022032218281674244349', '未知门店', '2022032218273812072668', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022032315510436332105', '昆明软装', '08d6e83120f04e2d95f09cbca5e39f16', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022032716030090609535', '彰泰店', '66c6f1cac06b4c4bb1480b8aca49c2f6', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022041615064261407950', '六盘水盘州店', '2024071313562470797942', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022051415403158232785', '新媒体开发汇总', '2b38df45299f4546bbfda194e569d0f3', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022053111523801747171', '武鸣店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022053111540278558506', '古城喜客喜', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022053111550506519840', '金湖喜客喜', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022060119502604274092', '集团管理中心', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022060119515959019205', '集团运营', '2022060119502604274092', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022060119534527275947', '深圳艺芯', '2022060119515959019205', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022061911250874161847', '版纳创艺', '2022062014273047782642', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022062011220607528647', '南昌九龙湖店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022062011243055046807', '桂林旗舰店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022062014273047782642', '西双版纳', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022070311384784393346', '出租事业部', '2022070518472495626516', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022070518085700053782', '怒江', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022070518331847193295', '黔西南', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022070518381885185511', '黔东南', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022070518472495626516', '岳阳', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022072815372742748086', '临汾', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022072815383767755118', '临汾尧都店', '2022072815372742748086', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022072815403271534598', '喜客喜国贸店', 'e45c702579534efda61cd695e8086a15', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022072815412532907783', '长垣店', '2024070211084353139636', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022090817063563596557', '上饶', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022090817271120821372', '上饶创艺', '2022090817063563596557', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2022110117362780593091', '普洱', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023030911333749343137', '抚州', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023030911360619225045', '抚州店', '2023030911333749343137', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023031818163416746182', '外地客户', '2024053015334577753416', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023040309415906513960', '钟山创艺', '8ac335ef10d84b59b49346e418364c49', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023041010410036478825', '总公司大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023041010413475549491', '昆明总公司', '2023041011144858603338', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023041011144858603338', '总公司昆明', '2023041010410036478825', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023041113373638209061', '梧州', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023041113380227385947', '梧州创艺', '2023041113373638209061', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023070413521774778352', '长沙喜客喜北店', 'dc0d2b767112418db8ff090e50641312', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023070413552100903676', '崇左店', 'ed72345703c947a78d52e0ec7a98d43e', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023080311090942703491', '南昌无印优装', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023081516452438129515', '赣州二店', '1984f2a74a294f8c811c2697aced2107', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023081710550449659999', '武汉', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023081710554710287633', '武汉创艺', '2023081710550449659999', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023100120352806758348', '芜湖喜客喜', 'c0b2057b7a8b4a3e9ffccbdb5325dea4', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023101312560535611694', '马鞍山喜客喜', '7bde4e97f6304c8d814a2fb7c7eaa7b9', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023111710445895556442', '九江', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023111710455644802200', '九江店', '2023111710445895556442', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023112917072943133969', '清镇', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2023120114221780567691', '于都店', '2024070114535121171820', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024010410071084791722', '长治喜客喜', 'ade25d3731284414b5bbbbaa114e2c48', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024012611191682416249', '长沙喜客喜南店', 'dc0d2b767112418db8ff090e50641312', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024030216574034637980', '玉米装饰', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024032317101793575508', '太原', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024032317103967539104', '太原创艺', '2024032317101793575508', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024032514132434517686', '南昌简客美家', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024040214032064595730', '景德镇', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024040214043198263573', '景德镇创艺', '2024040214032064595730', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024041209522423973921', '邯郸', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024041209525319626069', '邯郸创艺', '2024041209522423973921', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024041714283769375375', '长沙简客美家', 'dc0d2b767112418db8ff090e50641312', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024042712044785783705', '萍乡', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024042712051411418146', '萍乡创艺', '2024042712044785783705', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024050113532749332294', '永州', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024050113535570814629', '永州创艺', '2024050113532749332294', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024050116172858084885', '南昌局改专店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024052810530727922344', '普洱创艺', '2022110117362780593091', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024053015334577753416', '外地', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024062810325712543857', '喜客喜南昌红谷滩店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070114520200802260', '靖安', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070114535121171820', '于都', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070211084353139636', '长垣', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070216142488091552', '丽江', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070315433661436191', '长治索菲亚', 'ade25d3731284414b5bbbbaa114e2c48', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717193789975615', '贵开店新媒体', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717195729249747', '金阳店新媒体', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717221857581391', '遵义新媒体', '5d8784bd2b2143be93bde9d07d5429ea', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717224018009844', '铜仁新媒体', '7f91035da6694cb8956b4e4a5ac310d0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717240853215824', '万达新媒体', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717250709407696', '彩虹桥新媒体', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717253533322933', '桔山新媒体', '2022070518331847193295', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717255587544422', '施达新媒体', '2022070518331847193295', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717261544765169', '瓮安新媒体', '2022070518331847193295', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717270125201570', '水城新媒体', 'f3abebc26e7c45139be9daba7f444f2a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717272634274048', '盘州新媒体', 'f3abebc26e7c45139be9daba7f444f2a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717285642951246', '安顺新媒体', 'fb94dd1c526043f0ba7d40fbbf3adfe2', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717292693437169', '毕节新媒体', '0a9c3ff03733410f9afd87d1a702d42b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024070717321715345524', '凯里新媒体', '2022070518381885185511', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024071313562470797942', '盘州', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024071313570066679466', '瓮安', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024071813465459769656', '九龙湖话务店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024071813473649005362', '红谷滩话务店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024071914323742392061', '丰城', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024071915422435001165', '丰城店', '2024071914323742392061', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024072809133176282821', '喜客喜江西话务店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024080118100943708565', '河南大区管理中心', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024080214563716419922', '贵州CPM', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024081009311039342005', '萍乡话务店', '2024042712044785783705', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082115021000728908', '长沙禧悦信息', 'dc0d2b767112418db8ff090e50641312', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082411140125596685', 'AP设计', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710085348576081', '上饶话务店', '2022090817063563596557', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710102808671112', '武汉话务店', '2023081710550449659999', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710112178765062', '景德镇话务店', '2024040214032064595730', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710155618577505', '永州话务店', '2024050113532749332294', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710171413956925', '九江话务店', '2023111710445895556442', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710183435488254', '宜春香樟话务店', 'c02f7684352f402f80221dc213ea97c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710192973492115', '宜春袁州话务店', 'c02f7684352f402f80221dc213ea97c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710205351457406', '吉安话务店', '36a574e7af4e4ebead1e825b68e40d4a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082710215917736199', '抚州话务店', '2023030911333749343137', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024082711204421212912', '高安话务店', '1bc33b61c000467c80d503e4cf3b356a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024083109284674178346', 'AP设计店', '2024082411140125596685', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024083119013100005139', '清镇无优装', '2023112917072943133969', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024091617011216762750', '南昌九龙湖局改专店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024093016004829609576', '昆明话务店', '08d6e83120f04e2d95f09cbca5e39f16', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024101510172774536319', '临汾喜客喜', '2022072815372742748086', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024110310171207078677', '清镇无忧店', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024110713304256512430', '滁州喜客喜', 'ec7887ea33ba4374b2b70ec7d9a04e18', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2024110918061206896846', '小艺专属', '2022060119515959019205', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('232723ac1262480f99440c39c9248b76', '常州钟楼店', 'aac718bdd86c43a290241e979a9e712a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('23fc498d3a064f60bedcc459ad0eb04d', '湘西', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('26c5231cd3c84b659ef956c7b3dba61a', '怀化', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('27481aaf385c4e608cfdb41a8906056b', '北海', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2b38df45299f4546bbfda194e569d0f3', '楚雄', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2d603ba7a2774e909b03b087a3cd73af', '梦之岛店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2e3d988cfd704bdd8a2652c1b2967cd0', '贵阳', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2e97334df34947e89e98ab223fa4a0e9', '阜阳', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2ed61820f06e47f7bdbd400eb92db830', '贵阳精装', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2f190742807e48cd93afe4146d165baa', '滁州创艺', 'ec7887ea33ba4374b2b70ec7d9a04e18', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('2f28d8eff5e54bd2b2c6bce4fb2620b5', '东葛店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('305ccf74f70d423bac43f5f7e9e8c134', '常州湖塘店', 'aac718bdd86c43a290241e979a9e712a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('31d9378c07df41c084fff3b365e6394b', '钦州创艺', 'aad50a959a354ad48ea90a67993a3fe4', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('32563926fde440a6a0d431785bc05404', '来宾创艺', 'ca977bd2132149b6a7d45788eff607ed', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('36a574e7af4e4ebead1e825b68e40d4a', '吉安', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('3770e3639dba426ca511dce0b2c3fac8', '百色', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('39a91b5870d74d6aa6e3ca0bfbb35c07', '玉林', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('3a1e28f8c24d4c97a1fefabdb8ab81be', '大理喜客喜', '887d9d470959462da4f8c828c0cc8f44', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('4200256ae6c345d799a6ccda20942169', '都匀剑江店', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('433d31d8b3cb44e4b6b123be32240db2', '文山创艺', '59a3329db8e04abcb1ed16e7d0800807', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('44f352966a33474a8831d8f75ef11f8a', '湖南大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('46e6709c32e94357824e1e43b3760980', '靖安店', '2024070114520200802260', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('4ed6501d6ced404682e1b2ee01a07cd6', '赣州店', '1984f2a74a294f8c811c2697aced2107', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('50b3693c30a648eea089c0107d833c68', '池州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('55ab2d67ad5042ad8df756e38eb4a184', '百色创艺', '3770e3639dba426ca511dce0b2c3fac8', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('561fa2b317fb4866902f45d2cf813f2b', '保山', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('5853433827a64c4a82ee9a1654ec7485', '衡阳创艺', 'f8c6b72ccdbf470ab674ec1411af8089', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('59a3329db8e04abcb1ed16e7d0800807', '文山', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('5d8784bd2b2143be93bde9d07d5429ea', '遵义', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('62510495dab94b4885585c118ddf5735', '创艺装饰集团', '0', 0, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('65be0267cfef40e5bcdff715da442670', '临泉创艺', 'eaf5c25e4641422ea85f7e1968291158', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('66c6f1cac06b4c4bb1480b8aca49c2f6', '柳州', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('67523ad7317a4c3ca22d6ea58dc35d27', '贵港创艺', 'e1f450e27d6b41caba92aa4c3e567a68', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('6a85a2ec856e4988a2fdb44ab9a86596', '桂林', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('70edf93c06274ab3a706538cb427c7e6', '新乡', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('715e050578334e58b21004b0b8528fb2', '长沙创艺南店', 'dc0d2b767112418db8ff090e50641312', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7374075f70db4284aca8323bfa1e3e7e', '贵州大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('743466ed6c7e4972b64bd633b19fd2cc', '新乡创艺', '70edf93c06274ab3a706538cb427c7e6', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('745aea8e53554546983d453ea03b1ac3', '楚雄伟业', '2b38df45299f4546bbfda194e569d0f3', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('75a2ad98d7b548119fd569ce0131e571', '益阳', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('794f8a8b4b654dfa9d2f14d6e4949104', '凯里创艺', '2022070518381885185511', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('79a166eeeb4d476496f7e94cf6328e32', '毕节奥莱店', '0a9c3ff03733410f9afd87d1a702d42b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7bde4e97f6304c8d814a2fb7c7eaa7b9', '马鞍山', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7cb50793b50d403e92028c951cc60e00', '铜仁创艺', '7f91035da6694cb8956b4e4a5ac310d0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7ccadaaadda54340957f4505fa0d976e', '玉溪北店', '851afbf7e5804de0a24a23b77499f514', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7e745c4f63484f57b8dda7551a9bfcde', '河南大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7f2db94350cf429ab4bde1feb399b0e7', '玉溪南店', '851afbf7e5804de0a24a23b77499f514', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('7f91035da6694cb8956b4e4a5ac310d0', '铜仁', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('83710c5afe604e3abfc8f4c60f0e3182', '益阳创艺', '75a2ad98d7b548119fd569ce0131e571', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('8379d96a03374aaab4e3f7e7e616495d', '池州创艺', '50b3693c30a648eea089c0107d833c68', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('851afbf7e5804de0a24a23b77499f514', '玉溪', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('87cb0646f35949d7ae481dae51aafff3', '吉安店', '36a574e7af4e4ebead1e825b68e40d4a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('887d9d470959462da4f8c828c0cc8f44', '大理', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('8ac335ef10d84b59b49346e418364c49', '贺州', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('8b1e006077624e4b906d36d6cb6669e6', '六盘水水城店', 'f3abebc26e7c45139be9daba7f444f2a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('8b6018665fc848e8acb229936c6ba3a3', '铜陵创艺', 'f8b537fc4a9d4147bbf131c7805b03a0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('8e13c7af066e465cae2744b0a09cba3e', '柳州喜客喜', '66c6f1cac06b4c4bb1480b8aca49c2f6', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('9012bdbdd19944b68a28039f9c610306', '郴州喜客喜罗家井店', 'd62c8b84a18b464f86cf7d9e95b0bede', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('944f3799bdba4aa388ffabdefc443063', '兴义桔山店', '2022070518331847193295', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('94d7bc1303354b239589e8c4d7c1ff67', '桂林桂北店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('97592ece61eb47ffa35995abf4152eff', '清镇创艺', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('97af6f97b3824f019ef286d1524548b1', '阜阳旗舰店', '2e97334df34947e89e98ab223fa4a0e9', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('9c0a76e7df6f471faae78c61c728df1a', '临沧创艺', 'ed6ea4107b744f7f8d2166459866bba9', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('9c2aafe5cdda4af9b9cc79b8e7bc3097', '江西大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('9d1a82a0846642b0818c56b0c6723fd8', '都匀万达店', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('9e5f268ce91e4e50b05877ddcb443375', '广西大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('a570aed853924d7796025d6ae23df83d', '安顺龙凤店', 'fb94dd1c526043f0ba7d40fbbf3adfe2', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('a86f5940500e4bc88b0e502725f918b7', '喜客喜江西店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('aac718bdd86c43a290241e979a9e712a', '常州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('aad50a959a354ad48ea90a67993a3fe4', '钦州', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('aaec6acad0624287a23734d7917ad269', '大理南店', '887d9d470959462da4f8c828c0cc8f44', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ab6c901edeb842fbb9d32b2b0757aa04', '合肥', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ade25d3731284414b5bbbbaa114e2c48', '长治', '7e745c4f63484f57b8dda7551a9bfcde', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('b1fe59b79859466fb4c57d3d061388f5', '高安店', '1bc33b61c000467c80d503e4cf3b356a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('b52613fe59674d548fa4d6b488859d16', '宜春香樟店', 'c02f7684352f402f80221dc213ea97c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('b68b41ec014140af9daabb1888583612', '云南大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('b6f9f30a212d465683036b71745c00de', '新乡宅速美', '70edf93c06274ab3a706538cb427c7e6', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('bc05b174796c401da94fa928eeb07f98', '曲靖龙城', 'e45c702579534efda61cd695e8086a15', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c02f7684352f402f80221dc213ea97c1', '宜春', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c0b2057b7a8b4a3e9ffccbdb5325dea4', '芜湖', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c1091ebfb50843c3be267affb9461354', '桂林全州店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c11493afd1fb45248010e5be5fb05711', '防城港', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c481af8195cd4ce59037c89e4ff2ecf0', '怀化创艺', '26c5231cd3c84b659ef956c7b3dba61a', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c4e1556e8d6540dd9a9362dd57e84030', '合肥南店', 'ab6c901edeb842fbb9d32b2b0757aa04', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('c58b5d2af06a4633b686daf52bd62a9d', '马鞍山创艺', '7bde4e97f6304c8d814a2fb7c7eaa7b9', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ca977bd2132149b6a7d45788eff607ed', '来宾', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('cafd7873c8654f05bfaa64af1c948b24', '宣城', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('cb0544080c5f4cddbbc4a55b39aaf888', '曲靖锦华', 'e45c702579534efda61cd695e8086a15', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ce4a06e5f6184f33bc02ec0de8e368c1', '黔南', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('d4ce727d9a064845b9493070e3266a9f', '文山壮族苗族自治州', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('d62c8b84a18b464f86cf7d9e95b0bede', '郴州', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('d9b22f7436b247a8aad6ecd7fa5f4c2b', '南宁', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('dbb63b4b3dc44e859ad9cc4a48b8af40', '保山创艺', '561fa2b317fb4866902f45d2cf813f2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('dc0d2b767112418db8ff090e50641312', '长沙', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('dc267e91a0df442ab3a344f812ec7d1a', '长沙创艺总店', 'dc0d2b767112418db8ff090e50641312', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('dde351c1603a424bbfbf956ce66a45a6', '北湖店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('df96d5a9cf68413e864ab4c35abfdaf9', '安徽大区', '62510495dab94b4885585c118ddf5735', 1, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('e1f450e27d6b41caba92aa4c3e567a68', '贵港', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('e24ba53942b94431a7b20338e861877f', '宿州创艺', '1ad42349e1fe4585ad30046797be7585', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('e35b9b71357a4ec7abf1abae01e44748', '瓮安创艺', '2024071313570066679466', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('e45c702579534efda61cd695e8086a15', '曲靖', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('e518901e40d440858f24a08bf00d336c', '芜湖创艺', 'c0b2057b7a8b4a3e9ffccbdb5325dea4', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('e8b56c963b5b4a9189a65f6815987bad', '蒙自创艺', '05780461f55c4f2fa54d2a03705cfe4c', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('eaf5c25e4641422ea85f7e1968291158', '临泉', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('eb2bb3d206d54b6a9e274184f4a1fb23', '吉首创艺', '23fc498d3a064f60bedcc459ad0eb04d', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ec7887ea33ba4374b2b70ec7d9a04e18', '滁州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ed6ea4107b744f7f8d2166459866bba9', '临沧', 'b68b41ec014140af9daabb1888583612', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('ed72345703c947a78d52e0ec7a98d43e', '崇左', '9e5f268ce91e4e50b05877ddcb443375', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('f3abebc26e7c45139be9daba7f444f2a', '六盘水', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('f50ac9758b7f428ca94424001ae9589e', '贺州创艺', '8ac335ef10d84b59b49346e418364c49', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('f7a970a38f2944f6875d64c4f9216371', '贵阳金阳店', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('f8b537fc4a9d4147bbf131c7805b03a0', '铜陵', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('f8c6b72ccdbf470ab674ec1411af8089', '衡阳', '44f352966a33474a8831d8f75ef11f8a', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('f8d776e530974b3387c9de5266960eb3', '贵阳贵开店', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('fb5a77c560bd48a2a8acda97b8cb51ca', '宜春袁州店', 'c02f7684352f402f80221dc213ea97c1', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('fb921a5a066e472abe0c83cb4dd4ca4d', '南昌', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('fb94dd1c526043f0ba7d40fbbf3adfe2', '安顺', '7374075f70db4284aca8323bfa1e3e7e', 2, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
INSERT INTO `t_sys_company` VALUES ('fbd3ccfc0c464d03aa65dd58dc8e1316', '长治创艺', 'ade25d3731284414b5bbbbaa114e2c48', 3, '', '', '', '', '', '', '', '', '', '1', 0.00, '2024-12-19 09:28:25', '', '2024-12-19 09:28:25', '', '', '', '', 0.00, '', 0.00, '', '', '', '', 0.00);
COMMIT;

-- ----------------------------
-- Table structure for t_sys_config
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_config`;
CREATE TABLE `t_sys_config` (
  `config_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `config_key` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `config_value` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `config_desc` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`config_id`) USING BTREE,
  UNIQUE KEY `idx_config_key` (`config_key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_config
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_config` VALUES ('22010115920001', 'SUPER_ADMIN', '1', '超级管理员编号', '1', '2022-01-01 13:57:19', '', '2022-04-30 09:20:19', '');
INSERT INTO `t_sys_config` VALUES ('24122280690003', 'TEST', '111', '222', '333', '2024-12-23 15:16:44', '', '2024-12-23 15:16:51', '');
INSERT INTO `t_sys_config` VALUES ('24122337990004', 'PAY_STATE', '1', '1', '', '2024-12-24 15:28:04', '', '2024-12-24 15:28:04', '');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_dict`;
CREATE TABLE `t_sys_dict` (
  `dict_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `dict_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `dict_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `dict_value` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `dict_desc` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `dict_sort` int NOT NULL DEFAULT '0',
  `state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE KEY `idx_dict_key` (`dict_code`,`dict_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_dict` VALUES ('1120812340085', 'ROLE_TYPE', '1', '管理/工程/财务岗', '角色类型', 1, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:08:04', '');
INSERT INTO `t_sys_dict` VALUES ('1120812340086', 'ROLE_TYPE', '2', '店铺岗', '角色类型', 2, '1', '2021-12-08 14:31:16', '', '2024-02-19 18:28:22', '');
INSERT INTO `t_sys_dict` VALUES ('1120812340087', 'ROLE_TYPE', '3', '工人岗', '角色类型', 3, '1', '2021-12-08 14:31:16', '', '2024-02-19 18:28:30', '');
INSERT INTO `t_sys_dict` VALUES ('1120812340088', 'ROLE_TYPE', '4', '供货商岗', '角色类型', 4, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:07:52', '');
INSERT INTO `t_sys_dict` VALUES ('20210105123400001', 'STATE', '1', '有效', '状态', 1, '1', '2021-01-05 10:18:37', '', '2024-12-23 17:12:36', '');
INSERT INTO `t_sys_dict` VALUES ('20210105123400002', 'STATE', '2', '无效', '状态', 2, '1', '2021-01-05 10:18:38', '', '2021-12-07 22:26:41', '');
INSERT INTO `t_sys_dict` VALUES ('20210105123400003', 'URL_FILTER', '1', '白名单', 'URL过滤类型', 2, '1', '2021-01-05 10:18:38', '', '2024-12-30 15:02:07', '');
INSERT INTO `t_sys_dict` VALUES ('20210105123400004', 'URL_FILTER', '2', '非白名单', 'URL过滤类型', 1, '1', '2021-01-05 10:19:01', '', '2024-12-30 15:02:12', '');
INSERT INTO `t_sys_dict` VALUES ('20210105123400005', 'URL_TYPE', '1', '菜单', 'URL类型', 1, '1', '2021-01-05 10:18:38', '', '2021-01-05 10:18:38', '');
INSERT INTO `t_sys_dict` VALUES ('20210105123400006', 'URL_TYPE', '2', '功能', 'URL类型', 2, '1', '2021-01-05 10:18:38', '', '2021-01-05 10:18:38', '');
INSERT INTO `t_sys_dict` VALUES ('20210904123400001', 'USER_STATE', '1', '在职', '状态', 2, '1', '2021-01-05 10:18:37', '', '2021-12-08 11:37:09', '');
INSERT INTO `t_sys_dict` VALUES ('20210904123400002', 'USER_STATE', '2', '离职', '状态', 3, '1', '2021-01-05 10:18:37', '', '2021-12-08 11:37:10', '');
INSERT INTO `t_sys_dict` VALUES ('20210904123400003', 'USER_STATE', '3', '冻结', '状态', 4, '1', '2021-01-05 10:18:37', '', '2021-12-08 11:37:12', '');
INSERT INTO `t_sys_dict` VALUES ('20210904123400004', 'USER_STATE', '0', '未激活', '状态', 1, '1', '2021-12-08 11:36:44', '', '2021-12-08 11:37:05', '');
INSERT INTO `t_sys_dict` VALUES ('220430123400001', 'ROLE_TYPE', '5', '质检岗', '角色类型', 5, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:07:56', '');
INSERT INTO `t_sys_dict` VALUES ('220430123400002', 'ROLE_TYPE', '6', '平台业务员', '角色类型', 6, '1', '2021-12-08 14:31:16', '', '2022-04-30 10:20:05', '');
INSERT INTO `t_sys_dict` VALUES ('220430123400112', 'ROLE_TYPE', '99', '公司领导', '角色类型', 99, '1', '2021-12-08 14:31:16', '', '2022-04-30 10:20:05', '');
INSERT INTO `t_sys_dict` VALUES ('220430123401112', 'ROLE_TYPE', '9', '工程经理', '角色类型', 9, '1', '2021-12-08 14:31:16', '', '2022-04-30 10:20:05', '');
INSERT INTO `t_sys_dict` VALUES ('220520123400001', 'ENT_ROLE_TYPE', '1', '管理/工程/财务', '角色类型', 1, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:05:50', '');
INSERT INTO `t_sys_dict` VALUES ('220520123400002', 'ENT_ROLE_TYPE', '2', '店铺岗', '角色类型', 2, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:06:23', '');
INSERT INTO `t_sys_dict` VALUES ('220520123400003', 'ENT_ROLE_TYPE', '3', '工人岗', '角色类型', 3, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:06:26', '');
INSERT INTO `t_sys_dict` VALUES ('220520123400004', 'ENT_ROLE_TYPE', '4', '供货商岗', '角色类型', 4, '1', '2021-12-08 14:31:16', '', '2024-07-04 14:06:35', '');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_org
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_org`;
CREATE TABLE `t_sys_org` (
  `org_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `org_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `par_org_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `org_level` int NOT NULL DEFAULT '0',
  `cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `org_state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `default_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '是否默认部门',
  `admin_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '是否可以看到所有工单',
  `resp_user` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '责任人',
  `address` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '地址',
  PRIMARY KEY (`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_sys_org
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_org` VALUES ('028957d258214578a400768082363803', '合肥北店', 'ab6c901edeb842fbb9d32b2b0757aa04', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('02f484a19d984d009de43eeea5654da9', '昆明硬装', '08d6e83120f04e2d95f09cbca5e39f16', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('0455fa077bba4e0a8e02f6e81ee63fe1', '毕节杜鹃店', '0a9c3ff03733410f9afd87d1a702d42b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('05780461f55c4f2fa54d2a03705cfe4c', '红河', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('05eaeecef2784ef88cf5b25d06900d0d', '郴州创艺南塔店', 'd62c8b84a18b464f86cf7d9e95b0bede', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('075fff16157948c5968a0ab5e47e861b', '大理北店', '887d9d470959462da4f8c828c0cc8f44', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('08adfb9c92d649e4a6da8310d9b37694', '安阳', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('08d6e83120f04e2d95f09cbca5e39f16', '昆明', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('0947c880195242a180dd6c34510c3232', '遵义创艺', '5d8784bd2b2143be93bde9d07d5429ea', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('0a9c3ff03733410f9afd87d1a702d42b', '毕节', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('0c8aa72da56a4da384c1fe27ae9c9549', '安阳创艺', '08adfb9c92d649e4a6da8310d9b37694', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('12fd91e487dc4edf9da2e770431bd1c6', '宣城创艺', 'cafd7873c8654f05bfaa64af1c948b24', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('1552e34f95be42a49db3c6e34700107d', '桂林临桂店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('18604a83f64c4d9e91dc67b613752b4f', '兴义施达店', '2022070518331847193295', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('1984f2a74a294f8c811c2697aced2107', '赣州', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('19bfbfbf257749dfa792e5a5f00b680d', '南昌红谷滩店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('1ad42349e1fe4585ad30046797be7585', '宿州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('1bc33b61c000467c80d503e4cf3b356a', '高安', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022011216292015134983', '未知地区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022030917450369273537', '安顺玉龙店', 'fb94dd1c526043f0ba7d40fbbf3adfe2', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022032012071314248982', '桂平创艺', 'e1f450e27d6b41caba92aa4c3e567a68', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022032218273812072668', '未知城市', '2022011216292015134983', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022032218281674244349', '未知门店', '2022032218273812072668', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022032315510436332105', '昆明软装', '08d6e83120f04e2d95f09cbca5e39f16', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022032716030090609535', '彰泰店', '66c6f1cac06b4c4bb1480b8aca49c2f6', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022041615064261407950', '六盘水盘州店', '2024071313562470797942', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022051415403158232785', '新媒体开发汇总', '2b38df45299f4546bbfda194e569d0f3', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022053111523801747171', '武鸣店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022053111540278558506', '古城喜客喜', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022053111550506519840', '金湖喜客喜', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022060119502604274092', '集团管理中心', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022060119515959019205', '集团运营', '2022060119502604274092', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022060119534527275947', '深圳艺芯', '2022060119515959019205', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022061911250874161847', '版纳创艺', '2022062014273047782642', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022062011220607528647', '南昌九龙湖店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022062011243055046807', '桂林旗舰店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022062014273047782642', '西双版纳', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022070311384784393346', '出租事业部', '2022070518472495626516', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022070518085700053782', '怒江', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022070518331847193295', '黔西南', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022070518381885185511', '黔东南', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022070518472495626516', '岳阳', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022072815372742748086', '临汾', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022072815383767755118', '临汾尧都店', '2022072815372742748086', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022072815403271534598', '喜客喜国贸店', 'e45c702579534efda61cd695e8086a15', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022072815412532907783', '长垣店', '2024070211084353139636', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022090817063563596557', '上饶', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022090817271120821372', '上饶创艺', '2022090817063563596557', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2022110117362780593091', '普洱', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023030911333749343137', '抚州', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023030911360619225045', '抚州店', '2023030911333749343137', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023031818163416746182', '外地客户', '2024053015334577753416', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023040309415906513960', '钟山创艺', '8ac335ef10d84b59b49346e418364c49', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023041010410036478825', '总公司大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023041010413475549491', '昆明总公司', '2023041011144858603338', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023041011144858603338', '总公司昆明', '2023041010410036478825', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023041113373638209061', '梧州', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023041113380227385947', '梧州创艺', '2023041113373638209061', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023070413521774778352', '长沙喜客喜北店', 'dc0d2b767112418db8ff090e50641312', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023070413552100903676', '崇左店', 'ed72345703c947a78d52e0ec7a98d43e', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023080311090942703491', '南昌无印优装', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023081516452438129515', '赣州二店', '1984f2a74a294f8c811c2697aced2107', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023081710550449659999', '武汉', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023081710554710287633', '武汉创艺', '2023081710550449659999', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023100120352806758348', '芜湖喜客喜', 'c0b2057b7a8b4a3e9ffccbdb5325dea4', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023101312560535611694', '马鞍山喜客喜', '7bde4e97f6304c8d814a2fb7c7eaa7b9', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023111710445895556442', '九江', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023111710455644802200', '九江店', '2023111710445895556442', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023112917072943133969', '清镇', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2023120114221780567691', '于都店', '2024070114535121171820', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024010410071084791722', '长治喜客喜', 'ade25d3731284414b5bbbbaa114e2c48', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024012611191682416249', '长沙喜客喜南店', 'dc0d2b767112418db8ff090e50641312', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024030216574034637980', '玉米装饰', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024032317101793575508', '太原', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024032317103967539104', '太原创艺', '2024032317101793575508', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024032514132434517686', '南昌简客美家', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024040214032064595730', '景德镇', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024040214043198263573', '景德镇创艺', '2024040214032064595730', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024041209522423973921', '邯郸', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024041209525319626069', '邯郸创艺', '2024041209522423973921', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024041714283769375375', '长沙简客美家', 'dc0d2b767112418db8ff090e50641312', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024042712044785783705', '萍乡', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024042712051411418146', '萍乡创艺', '2024042712044785783705', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024050113532749332294', '永州', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024050113535570814629', '永州创艺', '2024050113532749332294', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024050116172858084885', '南昌局改专店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024052810530727922344', '普洱创艺', '2022110117362780593091', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024053015334577753416', '外地', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024062810325712543857', '喜客喜南昌红谷滩店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070114520200802260', '靖安', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070114535121171820', '于都', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070211084353139636', '长垣', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070216142488091552', '丽江', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070315433661436191', '长治索菲亚', 'ade25d3731284414b5bbbbaa114e2c48', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717193789975615', '贵开店新媒体', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717195729249747', '金阳店新媒体', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717221857581391', '遵义新媒体', '5d8784bd2b2143be93bde9d07d5429ea', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717224018009844', '铜仁新媒体', '7f91035da6694cb8956b4e4a5ac310d0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717240853215824', '万达新媒体', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717250709407696', '彩虹桥新媒体', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717253533322933', '桔山新媒体', '2022070518331847193295', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717255587544422', '施达新媒体', '2022070518331847193295', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717261544765169', '瓮安新媒体', '2022070518331847193295', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717270125201570', '水城新媒体', 'f3abebc26e7c45139be9daba7f444f2a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717272634274048', '盘州新媒体', 'f3abebc26e7c45139be9daba7f444f2a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717285642951246', '安顺新媒体', 'fb94dd1c526043f0ba7d40fbbf3adfe2', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717292693437169', '毕节新媒体', '0a9c3ff03733410f9afd87d1a702d42b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024070717321715345524', '凯里新媒体', '2022070518381885185511', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024071313562470797942', '盘州', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024071313570066679466', '瓮安', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024071813465459769656', '九龙湖话务店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024071813473649005362', '红谷滩话务店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024071914323742392061', '丰城', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024071915422435001165', '丰城店', '2024071914323742392061', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024072809133176282821', '喜客喜江西话务店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024080118100943708565', '河南大区管理中心', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024080214563716419922', '贵州CPM', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024081009311039342005', '萍乡话务店', '2024042712044785783705', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082115021000728908', '长沙禧悦信息', 'dc0d2b767112418db8ff090e50641312', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082411140125596685', 'AP设计', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710085348576081', '上饶话务店', '2022090817063563596557', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710102808671112', '武汉话务店', '2023081710550449659999', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710112178765062', '景德镇话务店', '2024040214032064595730', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710155618577505', '永州话务店', '2024050113532749332294', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710171413956925', '九江话务店', '2023111710445895556442', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710183435488254', '宜春香樟话务店', 'c02f7684352f402f80221dc213ea97c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710192973492115', '宜春袁州话务店', 'c02f7684352f402f80221dc213ea97c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710205351457406', '吉安话务店', '36a574e7af4e4ebead1e825b68e40d4a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082710215917736199', '抚州话务店', '2023030911333749343137', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024082711204421212912', '高安话务店', '1bc33b61c000467c80d503e4cf3b356a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024083109284674178346', 'AP设计店', '2024082411140125596685', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024083119013100005139', '清镇无优装', '2023112917072943133969', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024091617011216762750', '南昌九龙湖局改专店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024093016004829609576', '昆明话务店', '08d6e83120f04e2d95f09cbca5e39f16', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024101510172774536319', '临汾喜客喜', '2022072815372742748086', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024110310171207078677', '清镇无忧店', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024110713304256512430', '滁州喜客喜', 'ec7887ea33ba4374b2b70ec7d9a04e18', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2024110918061206896846', '小艺专属', '2022060119515959019205', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('232723ac1262480f99440c39c9248b76', '常州钟楼店', 'aac718bdd86c43a290241e979a9e712a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('23fc498d3a064f60bedcc459ad0eb04d', '湘西', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('26c5231cd3c84b659ef956c7b3dba61a', '怀化', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('27481aaf385c4e608cfdb41a8906056b', '北海', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2b38df45299f4546bbfda194e569d0f3', '楚雄', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2d603ba7a2774e909b03b087a3cd73af', '梦之岛店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2e3d988cfd704bdd8a2652c1b2967cd0', '贵阳', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2e97334df34947e89e98ab223fa4a0e9', '阜阳', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2ed61820f06e47f7bdbd400eb92db830', '贵阳精装', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2f190742807e48cd93afe4146d165baa', '滁州创艺', 'ec7887ea33ba4374b2b70ec7d9a04e18', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('2f28d8eff5e54bd2b2c6bce4fb2620b5', '东葛店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('305ccf74f70d423bac43f5f7e9e8c134', '常州湖塘店', 'aac718bdd86c43a290241e979a9e712a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('31d9378c07df41c084fff3b365e6394b', '钦州创艺', 'aad50a959a354ad48ea90a67993a3fe4', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('32563926fde440a6a0d431785bc05404', '来宾创艺', 'ca977bd2132149b6a7d45788eff607ed', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('36a574e7af4e4ebead1e825b68e40d4a', '吉安', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('3770e3639dba426ca511dce0b2c3fac8', '百色', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('39a91b5870d74d6aa6e3ca0bfbb35c07', '玉林', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('3a1e28f8c24d4c97a1fefabdb8ab81be', '大理喜客喜', '887d9d470959462da4f8c828c0cc8f44', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('4200256ae6c345d799a6ccda20942169', '都匀剑江店', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('433d31d8b3cb44e4b6b123be32240db2', '文山创艺', '59a3329db8e04abcb1ed16e7d0800807', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('44f352966a33474a8831d8f75ef11f8a', '湖南大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('46e6709c32e94357824e1e43b3760980', '靖安店', '2024070114520200802260', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('4ed6501d6ced404682e1b2ee01a07cd6', '赣州店', '1984f2a74a294f8c811c2697aced2107', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('50b3693c30a648eea089c0107d833c68', '池州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('55ab2d67ad5042ad8df756e38eb4a184', '百色创艺', '3770e3639dba426ca511dce0b2c3fac8', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('561fa2b317fb4866902f45d2cf813f2b', '保山', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('5853433827a64c4a82ee9a1654ec7485', '衡阳创艺', 'f8c6b72ccdbf470ab674ec1411af8089', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('59a3329db8e04abcb1ed16e7d0800807', '文山', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('5d8784bd2b2143be93bde9d07d5429ea', '遵义', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('62510495dab94b4885585c118ddf5735', '创艺装饰集团', '0', 0, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '1', '', '');
INSERT INTO `t_sys_org` VALUES ('65be0267cfef40e5bcdff715da442670', '临泉创艺', 'eaf5c25e4641422ea85f7e1968291158', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('66c6f1cac06b4c4bb1480b8aca49c2f6', '柳州', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('67523ad7317a4c3ca22d6ea58dc35d27', '贵港创艺', 'e1f450e27d6b41caba92aa4c3e567a68', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('6a85a2ec856e4988a2fdb44ab9a86596', '桂林', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('70edf93c06274ab3a706538cb427c7e6', '新乡', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('715e050578334e58b21004b0b8528fb2', '长沙创艺南店', 'dc0d2b767112418db8ff090e50641312', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7374075f70db4284aca8323bfa1e3e7e', '贵州大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('743466ed6c7e4972b64bd633b19fd2cc', '新乡创艺', '70edf93c06274ab3a706538cb427c7e6', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('745aea8e53554546983d453ea03b1ac3', '楚雄伟业', '2b38df45299f4546bbfda194e569d0f3', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('75a2ad98d7b548119fd569ce0131e571', '益阳', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('794f8a8b4b654dfa9d2f14d6e4949104', '凯里创艺', '2022070518381885185511', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('79a166eeeb4d476496f7e94cf6328e32', '毕节奥莱店', '0a9c3ff03733410f9afd87d1a702d42b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7bde4e97f6304c8d814a2fb7c7eaa7b9', '马鞍山', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7cb50793b50d403e92028c951cc60e00', '铜仁创艺', '7f91035da6694cb8956b4e4a5ac310d0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7ccadaaadda54340957f4505fa0d976e', '玉溪北店', '851afbf7e5804de0a24a23b77499f514', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7e745c4f63484f57b8dda7551a9bfcde', '河南大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7f2db94350cf429ab4bde1feb399b0e7', '玉溪南店', '851afbf7e5804de0a24a23b77499f514', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('7f91035da6694cb8956b4e4a5ac310d0', '铜仁', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('83710c5afe604e3abfc8f4c60f0e3182', '益阳创艺', '75a2ad98d7b548119fd569ce0131e571', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('8379d96a03374aaab4e3f7e7e616495d', '池州创艺', '50b3693c30a648eea089c0107d833c68', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('851afbf7e5804de0a24a23b77499f514', '玉溪', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('87cb0646f35949d7ae481dae51aafff3', '吉安店', '36a574e7af4e4ebead1e825b68e40d4a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('887d9d470959462da4f8c828c0cc8f44', '大理', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('8ac335ef10d84b59b49346e418364c49', '贺州', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('8b1e006077624e4b906d36d6cb6669e6', '六盘水水城店', 'f3abebc26e7c45139be9daba7f444f2a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('8b6018665fc848e8acb229936c6ba3a3', '铜陵创艺', 'f8b537fc4a9d4147bbf131c7805b03a0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('8e13c7af066e465cae2744b0a09cba3e', '柳州喜客喜', '66c6f1cac06b4c4bb1480b8aca49c2f6', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('9012bdbdd19944b68a28039f9c610306', '郴州喜客喜罗家井店', 'd62c8b84a18b464f86cf7d9e95b0bede', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('944f3799bdba4aa388ffabdefc443063', '兴义桔山店', '2022070518331847193295', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('94d7bc1303354b239589e8c4d7c1ff67', '桂林桂北店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('97592ece61eb47ffa35995abf4152eff', '清镇创艺', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('97af6f97b3824f019ef286d1524548b1', '阜阳旗舰店', '2e97334df34947e89e98ab223fa4a0e9', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('9c0a76e7df6f471faae78c61c728df1a', '临沧创艺', 'ed6ea4107b744f7f8d2166459866bba9', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('9c2aafe5cdda4af9b9cc79b8e7bc3097', '江西大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('9d1a82a0846642b0818c56b0c6723fd8', '都匀万达店', 'ce4a06e5f6184f33bc02ec0de8e368c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('9e5f268ce91e4e50b05877ddcb443375', '广西大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('a570aed853924d7796025d6ae23df83d', '安顺龙凤店', 'fb94dd1c526043f0ba7d40fbbf3adfe2', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('a86f5940500e4bc88b0e502725f918b7', '喜客喜江西店', 'fb921a5a066e472abe0c83cb4dd4ca4d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('aac718bdd86c43a290241e979a9e712a', '常州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('aad50a959a354ad48ea90a67993a3fe4', '钦州', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('aaec6acad0624287a23734d7917ad269', '大理南店', '887d9d470959462da4f8c828c0cc8f44', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ab6c901edeb842fbb9d32b2b0757aa04', '合肥', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ade25d3731284414b5bbbbaa114e2c48', '长治', '7e745c4f63484f57b8dda7551a9bfcde', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('b1fe59b79859466fb4c57d3d061388f5', '高安店', '1bc33b61c000467c80d503e4cf3b356a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('b52613fe59674d548fa4d6b488859d16', '宜春香樟店', 'c02f7684352f402f80221dc213ea97c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('b68b41ec014140af9daabb1888583612', '云南大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('b6f9f30a212d465683036b71745c00de', '新乡宅速美', '70edf93c06274ab3a706538cb427c7e6', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('bc05b174796c401da94fa928eeb07f98', '曲靖龙城', 'e45c702579534efda61cd695e8086a15', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c02f7684352f402f80221dc213ea97c1', '宜春', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c0b2057b7a8b4a3e9ffccbdb5325dea4', '芜湖', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c1091ebfb50843c3be267affb9461354', '桂林全州店', '6a85a2ec856e4988a2fdb44ab9a86596', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c11493afd1fb45248010e5be5fb05711', '防城港', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c481af8195cd4ce59037c89e4ff2ecf0', '怀化创艺', '26c5231cd3c84b659ef956c7b3dba61a', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c4e1556e8d6540dd9a9362dd57e84030', '合肥南店', 'ab6c901edeb842fbb9d32b2b0757aa04', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('c58b5d2af06a4633b686daf52bd62a9d', '马鞍山创艺', '7bde4e97f6304c8d814a2fb7c7eaa7b9', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ca977bd2132149b6a7d45788eff607ed', '来宾', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('cafd7873c8654f05bfaa64af1c948b24', '宣城', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('cb0544080c5f4cddbbc4a55b39aaf888', '曲靖锦华', 'e45c702579534efda61cd695e8086a15', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ce4a06e5f6184f33bc02ec0de8e368c1', '黔南', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('d4ce727d9a064845b9493070e3266a9f', '文山壮族苗族自治州', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('d62c8b84a18b464f86cf7d9e95b0bede', '郴州', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('d9b22f7436b247a8aad6ecd7fa5f4c2b', '南宁', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('dbb63b4b3dc44e859ad9cc4a48b8af40', '保山创艺', '561fa2b317fb4866902f45d2cf813f2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('dc0d2b767112418db8ff090e50641312', '长沙', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('dc267e91a0df442ab3a344f812ec7d1a', '长沙创艺总店', 'dc0d2b767112418db8ff090e50641312', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('dde351c1603a424bbfbf956ce66a45a6', '北湖店', 'd9b22f7436b247a8aad6ecd7fa5f4c2b', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('df96d5a9cf68413e864ab4c35abfdaf9', '安徽大区', '62510495dab94b4885585c118ddf5735', 1, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('e1f450e27d6b41caba92aa4c3e567a68', '贵港', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('e24ba53942b94431a7b20338e861877f', '宿州创艺', '1ad42349e1fe4585ad30046797be7585', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('e35b9b71357a4ec7abf1abae01e44748', '瓮安创艺', '2024071313570066679466', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('e45c702579534efda61cd695e8086a15', '曲靖', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('e518901e40d440858f24a08bf00d336c', '芜湖创艺', 'c0b2057b7a8b4a3e9ffccbdb5325dea4', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('e8b56c963b5b4a9189a65f6815987bad', '蒙自创艺', '05780461f55c4f2fa54d2a03705cfe4c', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('eaf5c25e4641422ea85f7e1968291158', '临泉', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('eb2bb3d206d54b6a9e274184f4a1fb23', '吉首创艺', '23fc498d3a064f60bedcc459ad0eb04d', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ec7887ea33ba4374b2b70ec7d9a04e18', '滁州', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ed6ea4107b744f7f8d2166459866bba9', '临沧', 'b68b41ec014140af9daabb1888583612', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('ed72345703c947a78d52e0ec7a98d43e', '崇左', '9e5f268ce91e4e50b05877ddcb443375', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('f3abebc26e7c45139be9daba7f444f2a', '六盘水', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('f50ac9758b7f428ca94424001ae9589e', '贺州创艺', '8ac335ef10d84b59b49346e418364c49', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('f7a970a38f2944f6875d64c4f9216371', '贵阳金阳店', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('f8b537fc4a9d4147bbf131c7805b03a0', '铜陵', 'df96d5a9cf68413e864ab4c35abfdaf9', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('f8c6b72ccdbf470ab674ec1411af8089', '衡阳', '44f352966a33474a8831d8f75ef11f8a', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('f8d776e530974b3387c9de5266960eb3', '贵阳贵开店', '2e3d988cfd704bdd8a2652c1b2967cd0', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('fb5a77c560bd48a2a8acda97b8cb51ca', '宜春袁州店', 'c02f7684352f402f80221dc213ea97c1', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('fb921a5a066e472abe0c83cb4dd4ca4d', '南昌', '9c2aafe5cdda4af9b9cc79b8e7bc3097', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('fb94dd1c526043f0ba7d40fbbf3adfe2', '安顺', '7374075f70db4284aca8323bfa1e3e7e', 2, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
INSERT INTO `t_sys_org` VALUES ('fbd3ccfc0c464d03aa65dd58dc8e1316', '长治创艺', 'ade25d3731284414b5bbbbaa114e2c48', 3, '2023080311090942703491', '1', '2024-11-12 16:37:57', '', '2024-12-19 09:30:06', '', '', '2', '', '');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
  `role_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `role_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `role_type` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `role_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `default_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '默认角色标志',
  `cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '企业编号',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `idx_role_code` (`role_code`,`cp_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role` VALUES ('2205231335001110', '管理员', '1', 'ENT_ADMIN', '1', '2023-05-23 17:31:28', '', '2023-05-23 17:31:28', '', '1', '22052098700001');
INSERT INTO `t_sys_role` VALUES ('2305233549000001', '企业管理员', '1', 'ENT_ADMIN', '1', '2023-05-23 17:06:25', '', '2024-12-19 09:30:48', '', '1', '2023080311090942703491');
INSERT INTO `t_sys_role` VALUES ('2305233549000011', '企业管理员', '1', 'ENT_ADMIN', '1', '2023-05-23 17:06:25', '', '2024-12-19 09:32:28', '', '1', 'dc267e91a0df442ab3a344f812ec7d1a');
INSERT INTO `t_sys_role` VALUES ('2305233549000021', '企业管理员', '1', 'ENT_ADMIN', '1', '2023-05-23 17:06:25', '', '2023-05-23 17:06:25', '', '1', '23061540890001');
INSERT INTO `t_sys_role` VALUES ('2305233549000031', '企业管理员', '1', 'ENT_ADMIN', '1', '2023-05-23 17:06:25', '', '2023-05-23 17:06:25', '', '1', '24031812340001');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_role_url
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_url`;
CREATE TABLE `t_sys_role_url` (
  `role_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '企业编号',
  `default_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '默认标志',
  PRIMARY KEY (`role_code`,`url_id`,`cp_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_role_url
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '10123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '11123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '1123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '12123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '13123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '14123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '16123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '17123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '18123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '19123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '20123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '20180426003', '2022-05-29 14:31:12', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '20210109123400001', '2022-05-29 14:31:12', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '20210224123400001', '2022-05-20 14:46:23', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '20210928123400001', '2022-05-29 14:31:12', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '21123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '2123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '220307123400001', '2022-09-04 11:12:08', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '2');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '220307123400002', '2022-09-04 11:12:08', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '2');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '220430123400010', '2022-09-04 11:12:08', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '2');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '23123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '24122212340001', '2022-09-06 15:46:31', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '2');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '24122212340002', '2022-09-06 15:46:31', '', '2024-12-19 09:30:06', '', '2023080311090942703491', '2');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '24123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '25123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '26123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '27123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '29123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '30123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '31123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '32123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '33123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '4123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '6123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '7123400001', '2022-09-04 11:12:08', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '2');
INSERT INTO `t_sys_role_url` VALUES ('ENT_ADMIN', '8123400001', '2022-05-29 14:31:12', '', '2024-12-28 10:09:27', '', '2023080311090942703491', '');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_seq
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_seq`;
CREATE TABLE `t_sys_seq` (
  `tab_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `seq_id` bigint NOT NULL DEFAULT '0',
  `cur_dt` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`tab_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_seq
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_sys_url
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_url`;
CREATE TABLE `t_sys_url` (
  `url_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `par_url_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url_desc` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url_sort` int NOT NULL DEFAULT '0',
  `url_level` int NOT NULL DEFAULT '0',
  `url_type` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url_filter` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `url_icon` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `ele_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`url_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_url
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_url` VALUES ('100000', '99999', '登录页面', '登录页面', '/sysUser/officeLogin', 100000, 2, '2', '1', '', '', '1', '2021-01-05 10:27:19', '', '2021-12-12 10:12:09', '0');
INSERT INTO `t_sys_url` VALUES ('100003', '99999', '获取配置', '获取配置', '/config/queryOneByPrimaryKey', 100003, 2, '2', '1', '', '', '1', '2021-01-05 10:27:20', '', '2019-02-16 10:52:32', '0');
INSERT INTO `t_sys_url` VALUES ('10123400001', '20210928123400001', '角色管理', '角色管理', '/html/auth/role.html', 2, 3, '1', '2', '', '', '1', '2021-01-05 10:27:19', '', '2024-12-28 10:08:47', '0');
INSERT INTO `t_sys_url` VALUES ('11123400001', '10123400001', '查询', '查询', '/sysRoleController/queryPageList', 11, 4, '2', '2', '', 'b_a2_roleQueryBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:12:11', '0');
INSERT INTO `t_sys_url` VALUES ('1120912340001', '99999', '验证码', '验证码', '/sysUser/genRandomCode', 100000, 2, '2', '1', '', '', '1', '2021-01-05 10:27:19', '', '2021-01-05 16:06:13', '0');
INSERT INTO `t_sys_url` VALUES ('1123400001', '0', '系统目录', '系统目录', '', 1, 0, '1', '2', '', '', '1', '2021-01-05 10:27:19', '', '2024-12-28 10:08:47', '0');
INSERT INTO `t_sys_url` VALUES ('12123400001', '10123400001', '新增', '新增', '/sysRoleController/insertRole', 12, 4, '2', '2', '', 'b_a2_roleAddBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:12:11', '0');
INSERT INTO `t_sys_url` VALUES ('13123400001', '10123400001', '修改', '修改', '/sysRoleController/updateRole', 13, 4, '2', '2', '', 'b_a2_roleUpdateBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:12:11', '0');
INSERT INTO `t_sys_url` VALUES ('14123400001', '10123400001', '删除', '删除', '/sysRoleController/deleteRole', 14, 4, '2', '2', '', 'b_a2_roleDelBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:12:11', '0');
INSERT INTO `t_sys_url` VALUES ('16123400001', '20210928123400001', '菜单配置', '菜单配置', '/html/auth/url.html', 3, 3, '1', '2', '', '', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:08:47', '0');
INSERT INTO `t_sys_url` VALUES ('17123400001', '16123400001', '菜单新增', '菜单新增', '/url/insertOne', 17, 4, '2', '2', '', 'b_a3_urlAddBtn', '2', '2021-01-05 10:27:20', '', '2024-12-28 10:12:52', '0');
INSERT INTO `t_sys_url` VALUES ('18123400001', '16123400001', '菜单修改', '菜单修改', '/url/updateOneByPrimaryKey', 18, 4, '2', '2', '', 'b_a3_urlSave', '2', '2021-01-05 10:27:20', '', '2024-12-28 10:12:52', '0');
INSERT INTO `t_sys_url` VALUES ('19123400001', '16123400001', '菜单删除', '菜单删除', '/url/deleteByPrimaryKey', 19, 4, '2', '2', '', 'b_a3_deleteUrl', '2', '2021-01-05 10:27:20', '', '2024-12-28 10:12:52', '0');
INSERT INTO `t_sys_url` VALUES ('20123400001', '16123400001', '菜单查询', '菜单查询', '/url/queryUrlNodeList', 20, 4, '2', '2', '', '', '2', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('20180426003', '4123400001', '修改密码', '修改密码', '/sysUserController/updateOne', 6, 4, '2', '2', ' ', 'b_a1_userChangePswd', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('20210109123400001', '4123400001', '修改用户状态', '修改用户状态', '/sysUserController/updateState', 5, 4, '2', '2', '', 'b_a1_userQuit,userJob', '1', '2021-01-09 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('20210224123400001', '4123400001', '下载用户信息', '下载用户信息', '/sysUserController/downLoad', 100000, 2, '2', '2', '', 'b_a1_userExpBtn', '1', '2021-02-24 23:09:18', '', '2024-12-28 10:09:10', '');
INSERT INTO `t_sys_url` VALUES ('20210928123400001', '2123400001', '权限管理', '权限管理', '', 1, 2, '1', '2', '', '', '1', '2021-01-05 10:27:19', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('2023040812340001', '99999', '获取字典项', '获取字典项', '/sysDict/queryValueByName', 100000, 2, '2', '1', '', '', '1', '2021-01-05 10:27:19', '', '2021-12-12 10:12:09', '0');
INSERT INTO `t_sys_url` VALUES ('21123400001', '2123400001', '公共管理', '公共管理', '', 2, 2, '1', '2', '', '', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('2123400001', '1123400001', '系统管理', '系统管理', '', 1, 1, '1', '2', '', '', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('220307123400001', '4123400001', '复职', '复职', '/sysUserController/userJob', 7, 4, '2', '2', '', 'b_a1_userJob', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('220307123400002', '4123400001', '离职交接', '离职交接', '/sysUserController/changeLiable', 8, 4, '2', '2', '', 'b_a1_userQuit', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('220430123400010', '4123400001', '修改身份信息', '修改身份信息', '/sysUserController/updateIdCard', 9, 4, '2', '2', '', 'b_a1_userIdUpd', '1', '2021-01-09 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('230202123400001', '4123400001', '离职', '离职', '/sysUserController/quit', 10, 4, '2', '2', '', 'b_a1_userNQuit', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('230524123400001', '99999', '获取用户公司列表', '获取用户公司列表', '/sysUser/selectUserCpList', 100000, 2, '2', '1', '', '', '1', '2021-01-05 10:27:19', '', '2021-12-12 10:12:09', '0');
INSERT INTO `t_sys_url` VALUES ('230715123400001', '99999', '获取公司树', '获取公司树', '/sysCompany/selectCpTree', 100000, 2, '2', '1', '', '', '1', '2021-02-24 23:09:18', '', '2024-12-19 12:09:01', '');
INSERT INTO `t_sys_url` VALUES ('23123400001', '21123400001', '配置管理', '配置管理', '/html/config/sys/config.html', 23, 3, '1', '2', '', '', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('24122212340001', '29123400001', '导出', '导出', '/sysDictController/download', 34, 4, '2', '2', '', 'b_c1_dictExpBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('24122212340002', '23123400001', '导出', '导出', '/sysConfig/download', 27, 4, '2', '2', '', 'b_c2_configDownload', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('24123400001', '23123400001', '查询', '查询', '/sysConfig/queryPageList', 24, 4, '2', '2', '', 'b_c2_configQueryBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('25123400001', '23123400001', '新增', '新增', '/sysConfig/insertOne', 25, 4, '2', '2', '', 'b_c2_configAddBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('26123400001', '23123400001', '修改', '修改', '/sysConfig/updateOne', 26, 4, '2', '2', '', 'b_c2_configUpdateBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('27123400001', '23123400001', '删除', '删除', '/sysConfig/deleteChecked', 27, 4, '2', '2', '', 'b_c2_configDelBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('29123400001', '21123400001', '字典管理', '字典管理', '/html/config/sys/dict.html', 29, 3, '1', '2', '', '', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('30123400001', '29123400001', '查询', '查询', '/sysDictController/queryPageList', 30, 4, '2', '2', '', 'b_c1_dictQueryBtn', '1', '2021-01-05 10:27:20', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('31123400001', '29123400001', '新增', '新增', '/sysDictController/insertOne', 31, 4, '2', '2', '', 'b_c1_dictAddBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('32123400001', '29123400001', '修改', '修改', '/sysDictController/updateOne', 32, 4, '2', '2', '', 'b_c1_dictUpdateBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('33123400001', '29123400001', '删除', '删除', '/sysDictController/deleteChecked', 33, 4, '2', '2', '', 'b_c1_dictDelBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('4123400001', '20210928123400001', '用户管理', '用户管理', '/html/auth/user.html', 1, 3, '1', '2', '', '', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:08:47', '0');
INSERT INTO `t_sys_url` VALUES ('5123400001', '4123400001', '查询', '查询', '/sysUserController/queryPageList', 1, 4, '2', '2', '', 'b_a1_userQueryBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('6123400001', '4123400001', '新增', '新增', '/sysUserController/insertOne', 2, 4, '2', '2', '', 'b_a1_userAddBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('7123400001', '4123400001', '修改', '修改', '/sysUserController/updateOne', 3, 4, '2', '2', '', 'b_a1_userUpdateBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
INSERT INTO `t_sys_url` VALUES ('8123400001', '4123400001', '删除', '删除', '/sysUserController/deleteChecked', 4, 4, '2', '2', '', 'b_a1_userDelBtn', '1', '2021-01-05 10:27:21', '', '2024-12-28 10:09:10', '0');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user` (
  `user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `login_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `password` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `email` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `user_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `phone` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `entry_tm` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `quit_tm` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `state` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `portrait` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `user_remark` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `idcard` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `cp_admin_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '是否企业管理员（1：是；2：否）',
  `batch_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '导入批次号',
  `init_pswd_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '是否初始密码',
  `work_area` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '施工区域',
  `user_level` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '等级',
  `idcard_front` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '身份证正面照片',
  `idcard_back` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '身份证反面照片',
  `open_id` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '微信openId',
  `insurance_flag` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '是否购买保险',
  `insurance_beg_dt` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '购买保险开始日期',
  `insurance_end_dt` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '购买保险结束日期',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `login_name` (`login_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_user
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user` VALUES ('23052369080001', '18973172612', '1', '', '系统管理员', '', '20230523', '', '1', '2023-05-23 17:04:32', '', '2024-12-17 14:32:18', '', '', '', '', '1', '', '2', '', '', '', '', 'oS3kL61zSIcCjG9oY8C9j4yP26D8', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user_add
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_add`;
CREATE TABLE `t_sys_user_add` (
  `user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '用户编号    ',
  `rec_type` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '收款方式    ',
  `bank_card_no` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '结算银行卡号  ',
  `bank_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '结算银行开户行 ',
  `bank_brance_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '结算银行开户分行',
  `bank_user_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '结算银行户名  ',
  `deposit_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '押金金额    ',
  `standard_deposit_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '应缴押金金额  ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '创建用户',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '修改用户',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='系统用户附加表信息';

-- ----------------------------
-- Records of t_sys_user_add
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user_add` VALUES ('23052369080001', '', '', '', '', '', 0.00, 0.00, '2023-12-07 11:10:42', '23052369080001', '2023-12-07 12:34:43', '23052369080001');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user_cp
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_cp`;
CREATE TABLE `t_sys_user_cp` (
  `user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `org_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`,`cp_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_user_cp
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user_cp` VALUES ('23052369080001', '2023080311090942703491', '2023080311090942703491', '2023-05-25 20:57:53', '', '2024-12-25 10:00:19', '');
INSERT INTO `t_sys_user_cp` VALUES ('23052369080001', 'dc267e91a0df442ab3a344f812ec7d1a', '2205291594000002', '2023-07-28 09:19:13', '', '2024-12-19 09:32:27', '');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_role`;
CREATE TABLE `t_sys_user_role` (
  `user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `role_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_user_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `cp_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '企业编号',
  PRIMARY KEY (`user_id`,`role_code`,`cp_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of t_sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user_role` VALUES ('23052369080001', 'ENT_ADMIN', '2023-05-23 17:06:25', '', '2024-12-19 09:30:06', '', '2023080311090942703491');
INSERT INTO `t_sys_user_role` VALUES ('23052369080001', 'ENT_ADMIN', '2023-07-28 09:19:35', '', '2024-12-19 09:32:27', '', 'dc267e91a0df442ab3a344f812ec7d1a');
COMMIT;

-- ----------------------------
-- Table structure for tmpOrgLst
-- ----------------------------
DROP TABLE IF EXISTS `tmpOrgLst`;
CREATE TABLE `tmpOrgLst` (
  `sno` int NOT NULL AUTO_INCREMENT,
  `id` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `depth` int DEFAULT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of tmpOrgLst
-- ----------------------------
BEGIN;
INSERT INTO `tmpOrgLst` VALUES (6, '2023080311090942703491', 0);
COMMIT;

-- ----------------------------
-- Procedure structure for CREATE_ORG_CHILDLIST
-- ----------------------------
DROP PROCEDURE IF EXISTS `CREATE_ORG_CHILDLIST`;
delimiter ;;
CREATE PROCEDURE `CREATE_ORG_CHILDLIST`(IN rootId varchar(64),IN nDepth INT)
BEGIN
 DECLARE done INT DEFAULT 0;
 DECLARE b varchar(32);
 DECLARE cur1 CURSOR FOR SELECT org_id FROM t_sys_org where par_org_id=rootId;
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 set max_sp_recursion_depth=10;
 insert into tmpOrgLst values (null,rootId,nDepth);
 OPEN cur1;
 FETCH cur1 INTO b;
 WHILE done=0 DO
         CALL CREATE_ORG_CHILDLIST(b,nDepth+1);
         FETCH cur1 INTO b;
 END WHILE;
 CLOSE cur1;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for GET_ALL_ORG_BY_PARID
-- ----------------------------
DROP PROCEDURE IF EXISTS `GET_ALL_ORG_BY_PARID`;
delimiter ;;
CREATE PROCEDURE `GET_ALL_ORG_BY_PARID`(IN rootId varchar(64))
BEGIN
 CREATE TABLE IF NOT EXISTS tmpOrgLst
  (sno int primary key auto_increment,id varchar(32),depth int);
 DELETE FROM tmpOrgLst;
 set max_sp_recursion_depth=10;
 CALL CREATE_ORG_CHILDLIST(rootId,0);
 select t_sys_org.org_id,t_sys_org.org_name,t_sys_org.org_level from tmpOrgLst,t_sys_org where tmpOrgLst.id=t_sys_org.org_id and t_sys_org.org_state = 1 and t_sys_org.org_level>1 order by tmpOrgLst.sno;
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
